The Report2Excel ActiveX Control gives you the simple ability to output a recordset to an Excel Spreadsheet that is formatted in font and color to your specifications. Since this control does output the recordset to Excel 97, Excel 97 must be installed on the developers and end-users' machines.
Report2Excel was developed and Copyrighted by Greg Buczek 1998. Do not distribute the license file with your applications. Address questions, comments, complaints to gbuczek@thuntek.net.
Calling the ReportExecute exports the data into Excel. It is helpful to surround this call with code that turns your mousepointer into an hourglass and then back.
Properties
╖ (Name) - Name of the control as referred to in your code.
╖ ColumnWidth - the width of the columns as they appear in the Excel spreadsheet.
╖ DataBackColor - This is the background color of the Excel spreadsheet for the area where the data appears.
╖ DatabaseName - A valid path to an Access database
╖ DataFont - Font used for the data portion of the Excel spreadsheet.
╖ DataForeColor - Text color for the data portion of the report.
╖ FieldNamesForHeaders - Boolean indicating whether the field names from the recordset should be used as the column headings. Remember that you can use the "as" keyword in your SQL statement to give a field a different name if the name is not user friendly as in:
select [fname] as [First Name] from [emps];
╖ HeaderBackColor - This is the background color of the Excel Spreadsheet for the area where the headers appear.
╖ HeaderFont - Font used for the header portion of the Excel spreadsheet.
╖ HeaderForeColor - Text color for the header portion of the report.
╖ Index - Used to create an array of the control.
╖ InnerBorder - Thickness of the border for the Inner portion of the spreadsheet.
╖ OuterBorder - Thickness of the border for the Outer portion of the spreadsheet.
╖ PageCaption - Title to appear on the tab portion of the Spreadsheet.
╖ Recordset - A valid table name, query name or SQL statement for the database specified in the database name property.